var nodeXlsx = require('node-xlsx');
var excelData = nodeXlsx.parse('./20160818/20160818.xlsx');
var arr = [];
var l = excelData.length;
for (var i = 0; i < l; i++) {
    var ar = excelData[i].data;
    var ll = ar.length;
    for (var j = 1; j < ll; j++) {
        var aa = ar[j];
        if (aa[1] && aa[1] == 'ASHX') {
            continue;
        }
        if (aa[1] && aa[1] == 'HAUD') {
            continue;
        }
        if (aa[1] && aa[1] == 'HEWY') {
            continue;
        }
        var symbol = aa[1] == 'undefined' ? '' : aa[1];
        arr.push({
                etf_symbol: symbol,
                name: aa[2] == 'undefined' ? '' : aa[2],
                symbol: '.' + symbol,
                investingID: aa[8] == 'undefined' ? '' : aa[8]
            }
        );
    }
}
module.exports = arr;